-- -----------------------------------------------------------------------------
-- -----------------------------------------------------------------------------
-- 
-- Initial Population
-- 
-- -----------------------------------------------------------------------------
-- -----------------------------------------------------------------------------

-- dbo.CfgCtrl
DELETE FROM dbo.CfgCtrl WHERE CfgCtrlKey IN ( 'MinMinutesBetweenVolSpcSamples' )
GO

INSERT dbo.CfgCtrl
     ( CfgCtrlKey, CfgCtrlValue, CfgCtrlDescription )
SELECT 'MinMinutesBetweenVolSpcSamples', '55', 'Minimum number of minutes between VolumeSpace samples'
GO

-- Populate dbo.EventLogType
TRUNCATE TABLE dbo.EventLog
GO
DELETE FROM dbo.EventLogType 
GO

INSERT dbo.EventLogType 
     ( EventLogTypeId, EventLogTypeCd, EventLogTypeDesc ) 
SELECT 0, 'UNK', 'Unknown'
UNION ALL
SELECT 1, 'INFO', 'Informational'
UNION ALL
SELECT 2, 'WARN', 'Warning'
UNION ALL
SELECT 3, 'FAIL', 'Failure'
GO

-- dbo.Parameter
DELETE FROM dbo.Parameter
GO

INSERT dbo.Parameter
     ( ParameterId, ParameterCd, ParameterName, ParameterDefaultValue, ParamAllowMutliFlag, ParamMaxMultiCnt )
SELECT 100, 'MaxJobHistoryId', 'The maximum job history id for this server instance id', '0', 0, 0
UNION ALL
SELECT 101, 'MaxEventLogId', 'The maximum event log id for this database in a server instance.', '0', 1, -1
UNION ALL
SELECT 200, 'ELHDatabaseId', 'The database id to retrieve the Event Log History from', '1', 1, -1
UNION ALL
SELECT 201, 'ExecLogDatabaseId', 'The database id to retrieve the ExecutionLog, ExecutionLog2, or ExecutionLog3 from', '1', 1, -1 )
GO

-- dbo.SrvrInstncGrp
DELETE FROM [dbo].[SrvrInstncGrp]
GO

INSERT dbo.SrvrInstncGrp
     ( SrvrInstncGrpId, SrvrInstncGrpPriority, SrvrInstncGrpName)
SELECT 1, 0, 'Default Group'
GO

-- dbo.SrvrInstncType
DELETE FROM dbo.SrvrInstncType 
GO

INSERT dbo.SrvrInstncType 
     ( SrvrInstncTypeId, SrvrInstncTypeCd, SrvrInstncTypeName, OLEDBProviderName) 
SELECT 1, 'MSSQL', 'Microsoft SQL Server', 'SQLNCLI10'
UNION ALL
SELECT 2, 'ORACLE', 'Oracle', 'Do Not Know'
UNION ALL
SELECT 3, 'SYBASE', 'Sybase', 'Do Not Know'
UNION ALL
SELECT 4, 'DB2C', 'DB2-C', 'Do Not Know'
GO

-- dbo.Seq
TRUNCATE TABLE dbo.Seq
GO

INSERT dbo.Seq ( SeqName, SeqNumber ) VALUES ( 'PackageExecutionId', 0 )
GO

